Re: SELECT clause no relation found.

Поиск
Список
Период
Сортировка
От John Pfersich
Тема Re: SELECT clause no relation found.
Дата
Msg-id v04003a00bade161fa9fb@[12.83.80.221]
обсуждение исходный текст
Ответ на Re: SELECT clause no relation found.  (Barry Lind <blind@xythos.com>)
Список pgsql-jdbc
It could also be that the table was created as "person" (with the quotes)
instead of minus the quotes. SQL is suposed to be a caseless language, but
if you force a case structure on it, it will conform to it quite rigidly.
If you use case to define an object, you will be forced to continue to
specify the case.

>Mika,
>
>If you turn sql statement tracing on on the server, you could then see
>the exact sql statements that are being sent from the jdbc driver to the
>server.
>
>thanks,
>--Barry
>
>Mika Pesu wrote:
>> what's wrong with key sql
>>
>> select * from person;
>>
>> gives me error no person relation found
>>
>> but when i use
>> select * from "person"
>>
>> doesn't give any error.
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "David Wall"
Дата:
Сообщение: Re: Memroy leak with jdbc
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Memroy leak with jdbc